<%@page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="DBConnection.DB"%>
<%@page import="java.sql.*"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<title>table</title>
		<link href="../../css/layer.css" rel="stylesheet" type="text/css" />
		<script type="text/javascript" src="../../js/jquery-1.7.2.min.js"></script>
		<script type="text/javascript"
			src="../../js/jquery-ui-1.8.21.custom.min.js"></script>
	</head>
  
  <body>
    <%
        String id = request.getParameter("id");
		DB db = new DB();
		ResultSet rs = null;
		db.ConnectDB();
		String sql = "select * from tbl_unit_instrument,tbl_unit where unitinstrumentno='"+id+"' and tbl_unit_instrument.unitid=tbl_unit.unitid";
		rs = db.sm.executeQuery(sql);
        while (rs.next()) {
     %>
       <div class="table_list">
			<ul>
				<li>
					<p class="name">
						仪器名称:
					</p>
					<p class="name_id"><%=rs.getString("instrumentname")%></p>
				</li>
				<li class="color3">
					<p class="name">
						联系人:
					</p>
					<p class="name_id"><%=rs.getString("linkman")%></p>
				</li>
				<li>
					<p class="name">
						联系电话:
					</p>
				    <p class="name_id"><%=rs.getString("telephone")%></p>
				</li>
				<li class="color3">
					<p class="name">
						email:
					</p>
					<p class="name_id"><%=rs.getString("email")%></p>
				</li>
				<li>
					<p class="name">
						所属单位:
					</p>
				     <p class="name_id"><a href="dw.jsp?id=<%=rs.getString("unitid") %>"><%=rs.getString("unitname")%></a></p>
				</li>
				<li class="color3">
					<p class="name">
						所属部门:
					</p>
					<p class="name_id"><%=rs.getString("department")%></p>
				</li>
				<li>
					<p class="name">
						制造厂商:
					</p>
				    <p class="name_id"><%=rs.getString("manufacturer")%></p>
				</li>
				<li class="color3">
					<p class="name">
						仪器指标:
					</p>
					<p class="name_id"><%=rs.getString("guideline")%></p>
				</li>
				<li>
					<p class="name">
					          仪器功能:
					</p>
				    <p class="name_id"><%=rs.getString("functionfeatures")%></p>
				</li>
			</ul>
		</div>
     <%
       }
       db.CloseDB();
      %>
      <script>
      window.parent.$("#fanhui").show();
      window.parent.$("#fanhui").attr("onclick","new function(){window.history.back();}");
      </script>
  </body>
</html>